Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

or parse the view's Columns and...

...evaluate each column's Formula or ItemName against the current document.

For example:

Dim ws As New NotesUIWorkspace()
Dim uiVw As NotesUIView
Dim vw As NotesView
Dim entries As NotesViewEntryCollection
Dim entry As NotesViewEntry
Dim columns, value

Set uiVw = ws.CurrentView
Set vw = uiVw.View
columns = vw.Columns
Set entries = vw.AllEntries
Set entry = entries.GetFirstEntry()
Do Until entry Is Nothing
Forall c In columns
If c.IsFormula Then
value = Evaluate(c.Formula, entry.Document)
Else
value = entry.Document.GetItemValue(c.ItemName)
End If

' Your code here: copy value to a cell in Excel

End Forall
Set entry = entries.GetNextEntry(entry)
Loop


Feedback response number JSAK8RYANW created by ~Chris Frofootherobu on 03/01/2012

Copy Selected as Table and 22.75 in... (~Vanessa Minjum... 27.Feb.12)
. . Write it direct from docs to file (~Fritz Quethipi... 28.Feb.12)
. . . . Values are only in view, not on doc... (~Vanessa Minjum... 28.Feb.12)
. . . . . . or parse the view's Columns and... (~Fred Asatumibu... 1.Mar.12)
. . . . . . . . parse the column and evaluate formu... (~Vanessa Minjum... 1.Mar.12)
. . . . . . If it's a constant... (~Fritz Quethipi... 29.Feb.12)
. . . . . . . . Constant in script - don't wanna do... (~Vanessa Minjum... 1.Mar.12)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS